Manual publication DB insertion from raw text using syntax features

Publications and conferences of Dr. BOCICOR Maria Iuliana, Profesor Universitar

http://www.cs.ubbcluj.ro/~iuliana



In [1]:

    
class HelperMethods:
    @staticmethod
    def IsDate(text):
#         print("text")
#         print(text)
        for c in text.lstrip():
            if c not in "1234567890 ":
                return False
        return True



In [2]:

    
import pandas
import requests



In [3]:

    
page = requests.get('https://sites.google.com/view/iuliana-bocicor/research/publications')



In [4]:

    
data = page.text



In [5]:

    
from bs4 import BeautifulSoup



In [6]:

    
soup = BeautifulSoup(data)



In [142]:

    
def GetPublicationData_Number(text):
    title = text.split(',')[0].split('.')[1]
    try:
        date = [k.lstrip() for k in text.split(',') if HelperMethods.IsDate(k.lstrip())][0]
    except:
        date = ""
    return title, "", date



In [143]:

    
import re
def GetCoAuthorData(text):
#     print(text)
    val = re.search('\"[a-zA-Z ]+\"', text)
    title = val.group(0)
    val = re.search('Authors: [a-zA-Z,-. ]+ (?=Pages)', text)
    authors = val.group(0)
#     print(authors)
    return title, authors, ""



In [144]:

    
def GetPublicationData_A(text):
    print(text)
    print()
    text = text.replace("M. ", "")
    authors = text.split('.')[0]
    print("authors: ", authors)
    title = text.split('.')[1].lstrip(' \"')
    print("title: ", title)
    try:
        val = re.search('(19|20)[0-9]{2}\.', text)
        date = val.group(0).rstrip('.')
    except:
        date = ""
    
    print()
    
    
    return title, authors, date



In [145]:

    
pubs = []
# print(soup.find_all('div'))
for e in soup.find_all('div'):
    if "class" in e.attrs:
        if e.attrs["class"] == ["tyJCtd", "mGzaTb", "baZpAe"]:
            # for every pub entry
            for c in e.find_all("p", attrs={"class": "zfr3Q"}):
                if c.text == "":
                    continue
                if "co-author" in c.text:
                    rval = GetCoAuthorData(c.text)
                else:
                    features = c.text.split('.')
                    if features[0].isdecimal():
                        rval = GetPublicationData_Number(c.text)
                    else:
                        rval = GetPublicationData_A(c.text)
                pubs.append(rval)









    



Szuhai, Iulia-Monica, Maria Iuliana Bocicor, Emilia-Loredana Pop, Ioan-Gabriel Mircea, and Cristina Mircea. "Investigating Differences between Ancient and Modern Bacterial DNA in Dental Calculus via Autoencoders." In 2019 21st International Symposium on Symbolic and Numeric Algorithms for Scientific Computing (SYNASC), pp. 141-147. IEEE, 2019. 

authors:  Szuhai, Iulia-Monica, Maria Iuliana Bocicor, Emilia-Loredana Pop, Ioan-Gabriel Mircea, and Cristina Mircea
title:  Investigating Differences between Ancient and Modern Bacterial DNA in Dental Calculus via Autoencoders

Iuliana Marin, Maria-Iuliana Bocicor, Arthur-Jozsef Molnar. Indoor Localisation with Intelligent Luminaires for Home Monitoring. In Proceedings of the 14th International Conference on Evaluation of Novel Approaches to Software Engineering (ENASE 2019), pages 464-471, ISBN: 978-989-758-375-9, DOI: 10.5220/0007751304640471, 2019.

authors:  Iuliana Marin, Maria-Iuliana Bocicor, Arthur-Jozsef Molnar
title:  Indoor Localisation with Intelligent Luminaires for Home Monitoring

Mihai Teletin, Gabriela Czibula, and Maria-Iuliana Bocicor. "Using clustering models for uncovering proteins’ structural similarity." 2019 IEEE 13th International Symposium on Applied Computational Intelligence and Informatics (SACI). IEEE, 2019. 

authors:  Mihai Teletin, Gabriela Czibula, and Maria-Iuliana Bocicor
title:  Using clustering models for uncovering proteins’ structural similarity

Iuliana Bocicor, Arthur-Jozsef Molnar, Iuliana Marin, Nicolae Goga, David Cuesta Frau and Raúl Valor Pérez. Intelligent Decision Support for Pervasive Home Monitoring and Assisted Living. 2018 IEEE 14th International Conference on Intelligent Computer Communication and Processing (ICCP), pages 129 - 136, 2018.

authors:  Iuliana Bocicor, Arthur-Jozsef Molnar, Iuliana Marin, Nicolae Goga, David Cuesta Frau and Raúl Valor Pérez
title:  Intelligent Decision Support for Pervasive Home Monitoring and Assisted Living

Mihai Teletin, Gabriela Czibula, Maria-Iuliana Bocicor, Silvana Albert, Alessandro Pandini. Deep Autoencoders for Additional Insight into Protein Dynamics. Artificial Neural Networks and Machine Learning – ICANN 2018. Lecture Notes in Computer Science, vol 11140, pages 79-89. Springer, Cham. (ISI)

authors:  Mihai Teletin, Gabriela Czibula, Maria-Iuliana Bocicor, Silvana Albert, Alessandro Pandini
title:  Deep Autoencoders for Additional Insight into Protein Dynamics

Iuliana Marin, Andrei Vasilateanu, Arthur-Jozsef Molnar, Maria Iuliana Bocicor, David Cuesta-Frau, Antonio Molina-Pico, Nicolae Goga. i-Light - Intelligent Luminaire Based Platform for Home Monitoring and Assisted Living. Electronics 2018, 7(10), 220, doi:10.3390/electronics7100220. (ISI)

authors:  Iuliana Marin, Andrei Vasilateanu, Arthur-Jozsef Molnar, Maria Iuliana Bocicor, David Cuesta-Frau, Antonio Molina-Pico, Nicolae Goga
title:  i-Light - Intelligent Luminaire Based Platform for Home Monitoring and Assisted Living

Mihai Teletin, Gabriela Czibula, Silvana Albert, Maria-Iuliana Bocicor. Using unsupervised learning methods for enhancing protein structure insight. Procedia Computer Science, Volume 126, pages 19-28, 2018.

authors:  Mihai Teletin, Gabriela Czibula, Silvana Albert, Maria-Iuliana Bocicor
title:  Using unsupervised learning methods for enhancing protein structure insight

Sorin Hostiuc, Arthur-Jozsef Molnar, Alin Moldoveanu, Maria Aluaş, Florica Moldoveanu, Iuliana Bocicor, Maria-Iuliana Dascalu, Elisabeta Bădilă, Mihaela Hostiuc, Ionut Negoi. Patient autonomy and disclosure of material information about hospital-acquired infections. Infection and Drug Resistance, 2018:11, pages 369—375, 2018. (ISI)

authors:  Sorin Hostiuc, Arthur-Jozsef Molnar, Alin Moldoveanu, Maria Aluaş, Florica Moldoveanu, Iuliana Bocicor, Maria-Iuliana Dascalu, Elisabeta Bădilă, Mihaela Hostiuc, Ionut Negoi
title:  Patient autonomy and disclosure of material information about hospital-acquired infections

Maria Iuliana Bocicor, David Cuesta Frau, Ionut-Catalin Draghici, Nicolae Goga, Arthur-Jozsef Molnar, Raúl Valor Pérez, Andrei Vasilateanu. Cyber-Physical System for Assisted Living and Home Monitoring. Proceedings of the IEEE 13th International Conference on Intelligent Computer Communication and Processing (ICCP), 2017. (ISI) 

authors:  Maria Iuliana Bocicor, David Cuesta Frau, Ionut-Catalin Draghici, Nicolae Goga, Arthur-Jozsef Molnar, Raúl Valor Pérez, Andrei Vasilateanu
title:  Cyber-Physical System for Assisted Living and Home Monitoring

Ionut-Catalin Draghici, Monica Nastasia Mihailescu, Laurentiu Ilie Guta, Andrei Vasilateanu, Ionel-Bujorel Pavaloiu, Iuliana Bocicor, Arthur Molnar, Nicolae Goga. A Quantitative Research to Decide the User Requirements for the i-Light System. Proceedings of the 21st International Conference on Control Systems and Computer Science (CSCS), IEEE Computer Society, 2017. (ISI)

authors:  Ionut-Catalin Draghici, Monica Nastasia Mihailescu, Laurentiu Ilie Guta, Andrei Vasilateanu, Ionel-Bujorel Pavaloiu, Iuliana Bocicor, Arthur Molnar, Nicolae Goga
title:  A Quantitative Research to Decide the User Requirements for the i-Light System

Iuliana Bocicor, Maria Dascălu, Agnieszka Gaczowska, Sorin Hostiuc, Alin Moldoveanu, Antonio Molina, Arthur-Jozsef Molnar, Ionuț Negoi and Vlad Racoviță. Wireless Sensor Network based System for the Prevention of Hospital Acquired Infections. Proceedings of the 12th International Conference on Evaluation of Novel Software Approaches to Software Engineering (ENASE2017), Vol. 1 – 978-989-758-250-9, 2017.

authors:  Iuliana Bocicor, Maria Dascălu, Agnieszka Gaczowska, Sorin Hostiuc, Alin Moldoveanu, Antonio Molina, Arthur-Jozsef Molnar, Ionuț Negoi and Vlad Racoviță
title:  Wireless Sensor Network based System for the Prevention of Hospital Acquired Infections

Maria Iuliana Bocicor, Alessandro Pandini, Gabriela Czibula, Silvana Albert and Mihai Teletin. Using Computational Intelligence Models for Additional Insight into Protein Structure. Studia Universitatis “Babes-Bolyai", Informatica, 62 (1), 107-119, 2017.

authors:  Maria Iuliana Bocicor, Alessandro Pandini, Gabriela Czibula, Silvana Albert and Mihai Teletin
title:  Using Computational Intelligence Models for Additional Insight into Protein Structure

Ioan Gabriel Mircea, Maria Iuliana Bocicor, Gabriela Czibula. A Reinforcement Learning Based Approach to Multiple Sequence Alignment. Proceedings of the 7th International Workshop Soft Computing Applications (SOFA 2016), Vol. 2, Springer, pages 54-70, 2018. (ISI)

authors:  Ioan Gabriel Mircea, Maria Iuliana Bocicor, Gabriela Czibula
title:  A Reinforcement Learning Based Approach to Multiple Sequence Alignment

Alex Graudenzi, Giulio Caravagna, Iuliana Bocicor, Claudia Cava, Marco Antoniotti, Giancarlo Mauri. Ordering cancer mutational profiles of cross-sectional copy number alterations. International Journal of Data Mining and Bioinformatics, Vol. 15, No. 1, pages 59-83, 2016. (ISI)

authors:  Alex Graudenzi, Giulio Caravagna, Iuliana Bocicor, Claudia Cava, Marco Antoniotti, Giancarlo Mauri
title:  Ordering cancer mutational profiles of cross-sectional copy number alterations

Maria Iuliana Bocicor, Arthur-Jozsef Molnar, Cristian Taslitchi. Preventing Hospital Acquired Infections through a Workflow-based Cyber-physical System. Proceedings of the 11th International Conference on Evaluation of Novel Software Approaches to Software Engineering (ENASE2016), pages 63-68, 2016. (ISI)

authors:  Maria Iuliana Bocicor, Arthur-Jozsef Molnar, Cristian Taslitchi
title:  Preventing Hospital Acquired Infections through a Workflow-based Cyber-physical System

N. Goga, A. Vasilateanu, M.N. Mihailescu, L. Guta, A. Molnar, I. Bocicor, L. Bolea, D. Stoica. Evaluating indoor localization using WiFi for patient tracking, 2016 International Symposium on Fundamentals of Electrical Engineering, IEEE Computer Society, 2016. (ISI)

authors:  N
title:  Goga, A

I. Negoi, M. Beuran, S. Paun, A. Moldoveanu, R. Negoi, I. Bocicor, A. Molnar, M. Hostiuc. Antibiotic prophylaxis in gynecological surgery. A literature review. GINECOeu, Vol. 12, No. 3, pages 142-145, 2016.

authors:  I
title:  Negoi, Beuran, S

Ioan Gabriel Mircea, Gabriela Czibula, Maria Iuliana Bocicor. A Q-learning Approach for Aligning Protein Sequences. Proceedings of the IEEE International Conference on Intelligent Computer Communication and Processing (ICCP2015), pages 51-58, 2015. (ISI)

authors:  Ioan Gabriel Mircea, Gabriela Czibula, Maria Iuliana Bocicor
title:  A Q-learning Approach for Aligning Protein Sequences

Adela Maria Sîrbu, Gabriela Czibula, Maria Iuliana Bocicor. Dynamic clustering of gene expression data using a fuzzy approach. In Proceedings of the 16th International Symposium on Symbolic and Numeric Algorithms for Scientific Computing (SYNASC '14), pages 220-227, IEEE Computer Society, 2014. (ISI)

authors:  Adela Maria Sîrbu, Gabriela Czibula, Maria Iuliana Bocicor
title:  Dynamic clustering of gene expression data using a fuzzy approach

Maria Iuliana Bocicor, Adela Sirbu, Gabriela Czibula. Dynamic core based clustering of gene expression data. International Journal of Innovative Computing Information and Control, Vol. 10, No. 3, pages 1051-1069, 2014. (ISI)

authors:  Maria Iuliana Bocicor, Adela Sirbu, Gabriela Czibula
title:  Dynamic core based clustering of gene expression data

Ioan Gabriel Mircea, Maria Iuliana Bocicor, Andra Dîncu. On Reinforcement Learning Based Multiple Sequence Alignment. Studia Universitatis “Babes-Bolyai", Informatica, LIX(2), pag. 50-65, 2014.

authors:  Ioan Gabriel Mircea, Maria Iuliana Bocicor, Andra Dîncu
title:  On Reinforcement Learning Based Multiple Sequence Alignment

Gabriela Czibula, Iuliana M. Bocicor, Istvan-Gergely Czibula. Temporal Ordering of Cancer Microarray Data through a Reinforcement Learning Based Approach. PLoS ONE 8(4), 2013. (ISI)

authors:  Gabriela Czibula, Iuliana Bocicor, Istvan-Gergely Czibula
title:  Temporal Ordering of Cancer Microarray Data through a Reinforcement Learning Based Approach

Gabriela Czibula, Istvan Gergely Czibula and Iuliana M. Bocicor. A Comparison of Reinforcement Learning based Models for the DNA Fragment Assembly Problem. Studia Universitatis “Babes-Bolyai", Informatica, LVIII(2), pages 90-102, 2013.

authors:  Gabriela Czibula, Istvan Gergely Czibula and Iuliana Bocicor
title:  A Comparison of Reinforcement Learning based Models for the DNA Fragment Assembly Problem

Adela Sîrbu and Maria Iuliana Bocicor. A Dynamic Approach for Hierarchical Clustering of Gene Expression Data. Proceedings of the 9th International Conference on Intelligent Computer Communication and Processing (ICCP2013), pages 3-6, IEEE Computer Society, 2013.

authors:  Adela Sîrbu and Maria Iuliana Bocicor
title:  A Dynamic Approach for Hierarchical Clustering of Gene Expression Data

Alexandru Radovici, Ioana Culic, Iuliana Bocicor, Alexandru Armean, Madalin Ene. Platformă educațională care permite programarea dispozitivelor embedded din Cloud – Wyliodrin. Conferinţa Naţională de Învăţământ Virtual, 9th Edition, Universitatea din București, pag. 57 – 61, 2013.

authors:  Alexandru Radovici, Ioana Culic, Iuliana Bocicor, Alexandru Armean, Madalin Ene
title:  Platformă educațională care permite programarea dispozitivelor embedded din Cloud – Wyliodrin

Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula. Promoter Sequences Prediction Using Relational Association Rule Mining. Evolutionary Bioinformatics vol. 8, pages 181-196, 2012. (ISI)

authors:  Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula
title:  Promoter Sequences Prediction Using Relational Association Rule Mining

Iuliana M. Bocicor. A Study on using Reinforcement Learning for Temporal Ordering of Biological Samples. Studia Universitatis “Babes-Bolyai", Informatica, LVII(4), pages 63-74, 2012.

authors:  Iuliana Bocicor
title:  A Study on using Reinforcement Learning for Temporal Ordering of Biological Samples

Iuliana M. Bocicor, Giulio Caravagna, Alex Graudenzi, Claudia Cava, Giancarlo Mauri, Marco Antoniotti. Ordering copy number alteration data to analyze colorectal cancer progression. EMBnet.journal, 18 Suppl. B (NETTAB 2012), pages 84-86, 2012.

authors:  Iuliana Bocicor, Giulio Caravagna, Alex Graudenzi, Claudia Cava, Giancarlo Mauri, Marco Antoniotti
title:  Ordering copy number alteration data to analyze colorectal cancer progression

Maria Iuliana Bocicor. A Study on Using Association Rules for Predicting Promoter Sequences. Studia Universitatis “Babes-Bolyai", Informatica, LVII(2), pages 32-42, 2012.

authors:  Maria Iuliana Bocicor
title:  A Study on Using Association Rules for Predicting Promoter Sequences

Maria Iuliana Bocicor. Experiments on Promoter Sequences Prediction using Association Rules. Lucrările Conferinței Naționale "Zilele Academice Clujene 2012, Departamentul de Informatică", Presa Universitară Clujeană, pag. 32 – 35, Cluj Napoca, 30 mai 2012.

authors:  Maria Iuliana Bocicor
title:  Experiments on Promoter Sequences Prediction using Association Rules

Maria Iuliana Bocicor, Gabriela Czibula and Istvan Gergely Czibula. A Distributed Q-Learning Approach to Fragment Assembly. SIC Journal, Studies in Informatics and Control, Vol. 20, Issue 3, pages 221-232, 2011. (ISI)

authors:  Maria Iuliana Bocicor, Gabriela Czibula and Istvan Gergely Czibula
title:  A Distributed Q-Learning Approach to Fragment Assembly

Maria Iuliana Bocicor, Gabriela Czibula and Istvan Gergely Czibula. A Reinforcement Learning Approach for Solving the Fragment Assembly Problem. In Proceedings of the 3th International Symposium on Symbolic and Numeric Algorithms for Scientific Computing (SYNASC '11), pages 191-198, IEEE Computer Society, 2011. (ISI)

authors:  Maria Iuliana Bocicor, Gabriela Czibula and Istvan Gergely Czibula
title:  A Reinforcement Learning Approach for Solving the Fragment Assembly Problem

Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula. A Distributed Reinforcement Learning Approach for Solving Optimization Problems. In Proceedings of the 5th International Conference on Communications and Information Technology (CIT '11) Greece, pages 25-30, 2011.

authors:  Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula
title:  A Distributed Reinforcement Learning Approach for Solving Optimization Problems

Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula. A Reinforcement Learning Model for Solving the Folding Problem. IJCTA – International Journal of Computer Technology and Applications, Vol. 2, Issue 1, pages 171-182, 2011.

authors:  Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula
title:  A Reinforcement Learning Model for Solving the Folding Problem

Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula. An Experiment on Protein Structure Prediction using Reinforcement Learning. Studia Universitatis “Babes-Bolyai", Informatica, LVI(1), pages 25-34, 2011.

authors:  Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula
title:  An Experiment on Protein Structure Prediction using Reinforcement Learning

Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula. Solving the Protein Folding Problem Using a Distributed Q-Learning Approach. International Journal of Computers, Volume 5, Issue 3, pages 404-413, 2011.

authors:  Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula
title:  Solving the Protein Folding Problem Using a Distributed Q-Learning Approach

Istvan Gergely Czibula, Gabriela Czibula and Maria Iuliana Bocicor. A Software Framework for Solving Combinatorial Optimization Tasks. Studia Universitatis “Babes-Bolyai", Informatica Special Issue, LVI(3), pages 3-8, 2011.

authors:  Istvan Gergely Czibula, Gabriela Czibula and Maria Iuliana Bocicor
title:  A Software Framework for Solving Combinatorial Optimization Tasks

Istvan Gergely Czibula, Gabriela Czibula and Maria Iuliana Bocicor. A Reinforcement Learning Based Framework for Solving Optimization Problems. In Post proceedings of Knowledge Engineering Principles and Techniques 2011, Presa Universitata Clujeana, 2011, pag. 235 -246. (ISI)

authors:  Istvan Gergely Czibula, Gabriela Czibula and Maria Iuliana Bocicor
title:  A Reinforcement Learning Based Framework for Solving Optimization Problems

Maria Iuliana Bocicor. Modele pentru problema plierii proteinei. Simpozion Național “Interferențe", Ediția a 2-a, 191-193 (2011).

authors:  Maria Iuliana Bocicor
title:  Modele pentru problema plierii proteinei

Maria Iuliana Bocicor. Bioinformatica si aplicatiile ei. Scoala Maramureseana, 222-223 (2010).

authors:  Maria Iuliana Bocicor
title:  Bioinformatica si aplicatiile ei

Maria Iuliana Bocicor. Algoritmi evolutivi aplicati in chemoterapie. Simpozion Național “Interferențe", Ediția a 1-a, 145-148 (2010).

authors:  Maria Iuliana Bocicor
title:  Algoritmi evolutivi aplicati in chemoterapie

Alexandru Radovici, Bocicor Maria Iuliana, Stoica Ovidiu. Peer-to-peer messenger-H3llo. 5th RoEduNet IEEE International Conference, Proceedings, 12-16, 2006 (ISI)

authors:  Alexandru Radovici, Bocicor Maria Iuliana, Stoica Ovidiu
title:  Peer-to-peer messenger-H3llo



In [146]:

    
for pub in pubs:
    print(pub)









    



(' Evaluation of Novel Approaches to Software Engineering', '', '2020')
('"Indoor Localization Techniques Within a Home Monitoring Platform"', 'Authors: Iuliana Marin, Maria Iuliana Bocicor, Arthur-Jozsef Molnar, ', '')
(' Evaluation of Novel Approaches to Software Engineering', '', '')
('"Technological Platform for the Prevention and Management of Healthcare Associated Infections and Outbreaks"', 'Authors: Maria Iuliana Bocicor, Maria Dascalu, Agnieszka Gaczowska, Sorin Hostiuc, Alin Moldoveanu, Antonio Molina, Arthur-Jozsef Molnar, Ionut Negoi, Vlad Racovita. ', '')
('Investigating Differences between Ancient and Modern Bacterial DNA in Dental Calculus via Autoencoders', 'Szuhai, Iulia-Monica, Maria Iuliana Bocicor, Emilia-Loredana Pop, Ioan-Gabriel Mircea, and Cristina Mircea', '2019')
('Indoor Localisation with Intelligent Luminaires for Home Monitoring', 'Iuliana Marin, Maria-Iuliana Bocicor, Arthur-Jozsef Molnar', '2019')
('Using clustering models for uncovering proteins’ structural similarity', 'Mihai Teletin, Gabriela Czibula, and Maria-Iuliana Bocicor', '2019')
('Intelligent Decision Support for Pervasive Home Monitoring and Assisted Living', 'Iuliana Bocicor, Arthur-Jozsef Molnar, Iuliana Marin, Nicolae Goga, David Cuesta Frau and Raúl Valor Pérez', '2018')
('Deep Autoencoders for Additional Insight into Protein Dynamics', 'Mihai Teletin, Gabriela Czibula, Maria-Iuliana Bocicor, Silvana Albert, Alessandro Pandini', '2018')
('i-Light - Intelligent Luminaire Based Platform for Home Monitoring and Assisted Living', 'Iuliana Marin, Andrei Vasilateanu, Arthur-Jozsef Molnar, Maria Iuliana Bocicor, David Cuesta-Frau, Antonio Molina-Pico, Nicolae Goga', '')
('Using unsupervised learning methods for enhancing protein structure insight', 'Mihai Teletin, Gabriela Czibula, Silvana Albert, Maria-Iuliana Bocicor', '2018')
('Patient autonomy and disclosure of material information about hospital-acquired infections', 'Sorin Hostiuc, Arthur-Jozsef Molnar, Alin Moldoveanu, Maria Aluaş, Florica Moldoveanu, Iuliana Bocicor, Maria-Iuliana Dascalu, Elisabeta Bădilă, Mihaela Hostiuc, Ionut Negoi', '2018')
('Cyber-Physical System for Assisted Living and Home Monitoring', 'Maria Iuliana Bocicor, David Cuesta Frau, Ionut-Catalin Draghici, Nicolae Goga, Arthur-Jozsef Molnar, Raúl Valor Pérez, Andrei Vasilateanu', '2017')
('A Quantitative Research to Decide the User Requirements for the i-Light System', 'Ionut-Catalin Draghici, Monica Nastasia Mihailescu, Laurentiu Ilie Guta, Andrei Vasilateanu, Ionel-Bujorel Pavaloiu, Iuliana Bocicor, Arthur Molnar, Nicolae Goga', '2017')
('Wireless Sensor Network based System for the Prevention of Hospital Acquired Infections', 'Iuliana Bocicor, Maria Dascălu, Agnieszka Gaczowska, Sorin Hostiuc, Alin Moldoveanu, Antonio Molina, Arthur-Jozsef Molnar, Ionuț Negoi and Vlad Racoviță', '2017')
('Using Computational Intelligence Models for Additional Insight into Protein Structure', 'Maria Iuliana Bocicor, Alessandro Pandini, Gabriela Czibula, Silvana Albert and Mihai Teletin', '2017')
('A Reinforcement Learning Based Approach to Multiple Sequence Alignment', 'Ioan Gabriel Mircea, Maria Iuliana Bocicor, Gabriela Czibula', '2018')
('Ordering cancer mutational profiles of cross-sectional copy number alterations', 'Alex Graudenzi, Giulio Caravagna, Iuliana Bocicor, Claudia Cava, Marco Antoniotti, Giancarlo Mauri', '2016')
('Preventing Hospital Acquired Infections through a Workflow-based Cyber-physical System', 'Maria Iuliana Bocicor, Arthur-Jozsef Molnar, Cristian Taslitchi', '2016')
('Goga, A', 'N', '2016')
('Negoi, Beuran, S', 'I', '2016')
('A Q-learning Approach for Aligning Protein Sequences', 'Ioan Gabriel Mircea, Gabriela Czibula, Maria Iuliana Bocicor', '2015')
('Dynamic clustering of gene expression data using a fuzzy approach', 'Adela Maria Sîrbu, Gabriela Czibula, Maria Iuliana Bocicor', '2014')
('Dynamic core based clustering of gene expression data', 'Maria Iuliana Bocicor, Adela Sirbu, Gabriela Czibula', '2014')
('On Reinforcement Learning Based Multiple Sequence Alignment', 'Ioan Gabriel Mircea, Maria Iuliana Bocicor, Andra Dîncu', '2014')
('Temporal Ordering of Cancer Microarray Data through a Reinforcement Learning Based Approach', 'Gabriela Czibula, Iuliana Bocicor, Istvan-Gergely Czibula', '2013')
('A Comparison of Reinforcement Learning based Models for the DNA Fragment Assembly Problem', 'Gabriela Czibula, Istvan Gergely Czibula and Iuliana Bocicor', '2013')
('A Dynamic Approach for Hierarchical Clustering of Gene Expression Data', 'Adela Sîrbu and Maria Iuliana Bocicor', '2013')
('Platformă educațională care permite programarea dispozitivelor embedded din Cloud – Wyliodrin', 'Alexandru Radovici, Ioana Culic, Iuliana Bocicor, Alexandru Armean, Madalin Ene', '2013')
('Promoter Sequences Prediction Using Relational Association Rule Mining', 'Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula', '2012')
('A Study on using Reinforcement Learning for Temporal Ordering of Biological Samples', 'Iuliana Bocicor', '2012')
('Ordering copy number alteration data to analyze colorectal cancer progression', 'Iuliana Bocicor, Giulio Caravagna, Alex Graudenzi, Claudia Cava, Giancarlo Mauri, Marco Antoniotti', '2012')
('A Study on Using Association Rules for Predicting Promoter Sequences', 'Maria Iuliana Bocicor', '2012')
('Experiments on Promoter Sequences Prediction using Association Rules', 'Maria Iuliana Bocicor', '2012')
('A Distributed Q-Learning Approach to Fragment Assembly', 'Maria Iuliana Bocicor, Gabriela Czibula and Istvan Gergely Czibula', '2011')
('A Reinforcement Learning Approach for Solving the Fragment Assembly Problem', 'Maria Iuliana Bocicor, Gabriela Czibula and Istvan Gergely Czibula', '2011')
('A Distributed Reinforcement Learning Approach for Solving Optimization Problems', 'Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula', '2011')
('A Reinforcement Learning Model for Solving the Folding Problem', 'Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula', '2011')
('An Experiment on Protein Structure Prediction using Reinforcement Learning', 'Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula', '2011')
('Solving the Protein Folding Problem Using a Distributed Q-Learning Approach', 'Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula', '2011')
('A Software Framework for Solving Combinatorial Optimization Tasks', 'Istvan Gergely Czibula, Gabriela Czibula and Maria Iuliana Bocicor', '2011')
('A Reinforcement Learning Based Framework for Solving Optimization Problems', 'Istvan Gergely Czibula, Gabriela Czibula and Maria Iuliana Bocicor', '')
('Modele pentru problema plierii proteinei', 'Maria Iuliana Bocicor', '')
('Bioinformatica si aplicatiile ei', 'Maria Iuliana Bocicor', '')
('Algoritmi evolutivi aplicati in chemoterapie', 'Maria Iuliana Bocicor', '')
('Peer-to-peer messenger-H3llo', 'Alexandru Radovici, Bocicor Maria Iuliana, Stoica Ovidiu', '')



In [140]:

    
print("Count: ", len(pubs))









    



Count:  46

DB Storage (TODO)

Time to store the entries in the papers DB table.



In [91]:

    
import mariadb
import json



In [92]:

    
with open('../credentials.json', 'r') as crd_json_fd:
    json_text = crd_json_fd.read()
    json_obj = json.loads(json_text)



In [93]:

    
credentials = json_obj["Credentials"]
username = credentials["username"]
password = credentials["password"]



In [94]:

    
table_name = "publications_cache"
db_name = "ubbcluj"



In [132]:

    
print(table_name)









    



publications_cache



In [95]:

    
mariadb_connection = mariadb.connect(user=username, password=password, database=db_name)
mariadb_cursor = mariadb_connection.cursor()



In [147]:

    
for paper in pubs:
    
    title = ""
    pub_date = ""
    authors = ""
    
    try:
        pub_date = paper[2].lstrip()
        pub_date = str(pub_date) + "-01-01"
        if len(pub_date) != 10:
            pub_date = ""
    except:
        pass
    
    try:
        title = paper[0].lstrip()
    except:
        pass
    
    try:
        authors = paper[1].lstrip()
    except AttributeError:
        pass
    
    
    
    insert_string = "INSERT INTO {0} SET ".format(table_name)
    insert_string += "Title=\'{0}\', ".format(title)
    insert_string += "ProfessorId=\'{0}\', ".format(7)
    if pub_date != "":
        insert_string += "PublicationDate=\'{0}\', ".format(str(pub_date))
    insert_string += "Authors=\'{0}\', ".format(authors)
    insert_string += "Affiliations=\'{0}\' ".format("")
    print(insert_string)
    

    try:
        mariadb_cursor.execute(insert_string)
    except mariadb.ProgrammingError as pe:
        print("Error")
        raise pe
    except mariadb.IntegrityError:
        continue









    



INSERT INTO publications_cache SET Title='Evaluation of Novel Approaches to Software Engineering', ProfessorId='7', PublicationDate='2020-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='"Indoor Localization Techniques Within a Home Monitoring Platform"', ProfessorId='7', Authors='Authors: Iuliana Marin, Maria Iuliana Bocicor, Arthur-Jozsef Molnar, ', Affiliations='' 
INSERT INTO publications_cache SET Title='Evaluation of Novel Approaches to Software Engineering', ProfessorId='7', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='"Technological Platform for the Prevention and Management of Healthcare Associated Infections and Outbreaks"', ProfessorId='7', Authors='Authors: Maria Iuliana Bocicor, Maria Dascalu, Agnieszka Gaczowska, Sorin Hostiuc, Alin Moldoveanu, Antonio Molina, Arthur-Jozsef Molnar, Ionut Negoi, Vlad Racovita. ', Affiliations='' 
INSERT INTO publications_cache SET Title='Investigating Differences between Ancient and Modern Bacterial DNA in Dental Calculus via Autoencoders', ProfessorId='7', PublicationDate='2019-01-01', Authors='Szuhai, Iulia-Monica, Maria Iuliana Bocicor, Emilia-Loredana Pop, Ioan-Gabriel Mircea, and Cristina Mircea', Affiliations='' 
INSERT INTO publications_cache SET Title='Indoor Localisation with Intelligent Luminaires for Home Monitoring', ProfessorId='7', PublicationDate='2019-01-01', Authors='Iuliana Marin, Maria-Iuliana Bocicor, Arthur-Jozsef Molnar', Affiliations='' 
INSERT INTO publications_cache SET Title='Using clustering models for uncovering proteins’ structural similarity', ProfessorId='7', PublicationDate='2019-01-01', Authors='Mihai Teletin, Gabriela Czibula, and Maria-Iuliana Bocicor', Affiliations='' 
INSERT INTO publications_cache SET Title='Intelligent Decision Support for Pervasive Home Monitoring and Assisted Living', ProfessorId='7', PublicationDate='2018-01-01', Authors='Iuliana Bocicor, Arthur-Jozsef Molnar, Iuliana Marin, Nicolae Goga, David Cuesta Frau and Raúl Valor Pérez', Affiliations='' 
INSERT INTO publications_cache SET Title='Deep Autoencoders for Additional Insight into Protein Dynamics', ProfessorId='7', PublicationDate='2018-01-01', Authors='Mihai Teletin, Gabriela Czibula, Maria-Iuliana Bocicor, Silvana Albert, Alessandro Pandini', Affiliations='' 
INSERT INTO publications_cache SET Title='i-Light - Intelligent Luminaire Based Platform for Home Monitoring and Assisted Living', ProfessorId='7', Authors='Iuliana Marin, Andrei Vasilateanu, Arthur-Jozsef Molnar, Maria Iuliana Bocicor, David Cuesta-Frau, Antonio Molina-Pico, Nicolae Goga', Affiliations='' 
INSERT INTO publications_cache SET Title='Using unsupervised learning methods for enhancing protein structure insight', ProfessorId='7', PublicationDate='2018-01-01', Authors='Mihai Teletin, Gabriela Czibula, Silvana Albert, Maria-Iuliana Bocicor', Affiliations='' 
INSERT INTO publications_cache SET Title='Patient autonomy and disclosure of material information about hospital-acquired infections', ProfessorId='7', PublicationDate='2018-01-01', Authors='Sorin Hostiuc, Arthur-Jozsef Molnar, Alin Moldoveanu, Maria Aluaş, Florica Moldoveanu, Iuliana Bocicor, Maria-Iuliana Dascalu, Elisabeta Bădilă, Mihaela Hostiuc, Ionut Negoi', Affiliations='' 
INSERT INTO publications_cache SET Title='Cyber-Physical System for Assisted Living and Home Monitoring', ProfessorId='7', PublicationDate='2017-01-01', Authors='Maria Iuliana Bocicor, David Cuesta Frau, Ionut-Catalin Draghici, Nicolae Goga, Arthur-Jozsef Molnar, Raúl Valor Pérez, Andrei Vasilateanu', Affiliations='' 
INSERT INTO publications_cache SET Title='A Quantitative Research to Decide the User Requirements for the i-Light System', ProfessorId='7', PublicationDate='2017-01-01', Authors='Ionut-Catalin Draghici, Monica Nastasia Mihailescu, Laurentiu Ilie Guta, Andrei Vasilateanu, Ionel-Bujorel Pavaloiu, Iuliana Bocicor, Arthur Molnar, Nicolae Goga', Affiliations='' 
INSERT INTO publications_cache SET Title='Wireless Sensor Network based System for the Prevention of Hospital Acquired Infections', ProfessorId='7', PublicationDate='2017-01-01', Authors='Iuliana Bocicor, Maria Dascălu, Agnieszka Gaczowska, Sorin Hostiuc, Alin Moldoveanu, Antonio Molina, Arthur-Jozsef Molnar, Ionuț Negoi and Vlad Racoviță', Affiliations='' 
INSERT INTO publications_cache SET Title='Using Computational Intelligence Models for Additional Insight into Protein Structure', ProfessorId='7', PublicationDate='2017-01-01', Authors='Maria Iuliana Bocicor, Alessandro Pandini, Gabriela Czibula, Silvana Albert and Mihai Teletin', Affiliations='' 
INSERT INTO publications_cache SET Title='A Reinforcement Learning Based Approach to Multiple Sequence Alignment', ProfessorId='7', PublicationDate='2018-01-01', Authors='Ioan Gabriel Mircea, Maria Iuliana Bocicor, Gabriela Czibula', Affiliations='' 
INSERT INTO publications_cache SET Title='Ordering cancer mutational profiles of cross-sectional copy number alterations', ProfessorId='7', PublicationDate='2016-01-01', Authors='Alex Graudenzi, Giulio Caravagna, Iuliana Bocicor, Claudia Cava, Marco Antoniotti, Giancarlo Mauri', Affiliations='' 
INSERT INTO publications_cache SET Title='Preventing Hospital Acquired Infections through a Workflow-based Cyber-physical System', ProfessorId='7', PublicationDate='2016-01-01', Authors='Maria Iuliana Bocicor, Arthur-Jozsef Molnar, Cristian Taslitchi', Affiliations='' 
INSERT INTO publications_cache SET Title='Goga, A', ProfessorId='7', PublicationDate='2016-01-01', Authors='N', Affiliations='' 
INSERT INTO publications_cache SET Title='Negoi, Beuran, S', ProfessorId='7', PublicationDate='2016-01-01', Authors='I', Affiliations='' 
INSERT INTO publications_cache SET Title='A Q-learning Approach for Aligning Protein Sequences', ProfessorId='7', PublicationDate='2015-01-01', Authors='Ioan Gabriel Mircea, Gabriela Czibula, Maria Iuliana Bocicor', Affiliations='' 
INSERT INTO publications_cache SET Title='Dynamic clustering of gene expression data using a fuzzy approach', ProfessorId='7', PublicationDate='2014-01-01', Authors='Adela Maria Sîrbu, Gabriela Czibula, Maria Iuliana Bocicor', Affiliations='' 
INSERT INTO publications_cache SET Title='Dynamic core based clustering of gene expression data', ProfessorId='7', PublicationDate='2014-01-01', Authors='Maria Iuliana Bocicor, Adela Sirbu, Gabriela Czibula', Affiliations='' 
INSERT INTO publications_cache SET Title='On Reinforcement Learning Based Multiple Sequence Alignment', ProfessorId='7', PublicationDate='2014-01-01', Authors='Ioan Gabriel Mircea, Maria Iuliana Bocicor, Andra Dîncu', Affiliations='' 
INSERT INTO publications_cache SET Title='Temporal Ordering of Cancer Microarray Data through a Reinforcement Learning Based Approach', ProfessorId='7', PublicationDate='2013-01-01', Authors='Gabriela Czibula, Iuliana Bocicor, Istvan-Gergely Czibula', Affiliations='' 
INSERT INTO publications_cache SET Title='A Comparison of Reinforcement Learning based Models for the DNA Fragment Assembly Problem', ProfessorId='7', PublicationDate='2013-01-01', Authors='Gabriela Czibula, Istvan Gergely Czibula and Iuliana Bocicor', Affiliations='' 
INSERT INTO publications_cache SET Title='A Dynamic Approach for Hierarchical Clustering of Gene Expression Data', ProfessorId='7', PublicationDate='2013-01-01', Authors='Adela Sîrbu and Maria Iuliana Bocicor', Affiliations='' 
INSERT INTO publications_cache SET Title='Platformă educațională care permite programarea dispozitivelor embedded din Cloud – Wyliodrin', ProfessorId='7', PublicationDate='2013-01-01', Authors='Alexandru Radovici, Ioana Culic, Iuliana Bocicor, Alexandru Armean, Madalin Ene', Affiliations='' 
INSERT INTO publications_cache SET Title='Promoter Sequences Prediction Using Relational Association Rule Mining', ProfessorId='7', PublicationDate='2012-01-01', Authors='Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula', Affiliations='' 
INSERT INTO publications_cache SET Title='A Study on using Reinforcement Learning for Temporal Ordering of Biological Samples', ProfessorId='7', PublicationDate='2012-01-01', Authors='Iuliana Bocicor', Affiliations='' 
INSERT INTO publications_cache SET Title='Ordering copy number alteration data to analyze colorectal cancer progression', ProfessorId='7', PublicationDate='2012-01-01', Authors='Iuliana Bocicor, Giulio Caravagna, Alex Graudenzi, Claudia Cava, Giancarlo Mauri, Marco Antoniotti', Affiliations='' 
INSERT INTO publications_cache SET Title='A Study on Using Association Rules for Predicting Promoter Sequences', ProfessorId='7', PublicationDate='2012-01-01', Authors='Maria Iuliana Bocicor', Affiliations='' 
INSERT INTO publications_cache SET Title='Experiments on Promoter Sequences Prediction using Association Rules', ProfessorId='7', PublicationDate='2012-01-01', Authors='Maria Iuliana Bocicor', Affiliations='' 
INSERT INTO publications_cache SET Title='A Distributed Q-Learning Approach to Fragment Assembly', ProfessorId='7', PublicationDate='2011-01-01', Authors='Maria Iuliana Bocicor, Gabriela Czibula and Istvan Gergely Czibula', Affiliations='' 
INSERT INTO publications_cache SET Title='A Reinforcement Learning Approach for Solving the Fragment Assembly Problem', ProfessorId='7', PublicationDate='2011-01-01', Authors='Maria Iuliana Bocicor, Gabriela Czibula and Istvan Gergely Czibula', Affiliations='' 
INSERT INTO publications_cache SET Title='A Distributed Reinforcement Learning Approach for Solving Optimization Problems', ProfessorId='7', PublicationDate='2011-01-01', Authors='Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula', Affiliations='' 
INSERT INTO publications_cache SET Title='A Reinforcement Learning Model for Solving the Folding Problem', ProfessorId='7', PublicationDate='2011-01-01', Authors='Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula', Affiliations='' 
INSERT INTO publications_cache SET Title='An Experiment on Protein Structure Prediction using Reinforcement Learning', ProfessorId='7', PublicationDate='2011-01-01', Authors='Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula', Affiliations='' 
INSERT INTO publications_cache SET Title='Solving the Protein Folding Problem Using a Distributed Q-Learning Approach', ProfessorId='7', PublicationDate='2011-01-01', Authors='Gabriela Czibula, Maria Iuliana Bocicor and Istvan Gergely Czibula', Affiliations='' 
INSERT INTO publications_cache SET Title='A Software Framework for Solving Combinatorial Optimization Tasks', ProfessorId='7', PublicationDate='2011-01-01', Authors='Istvan Gergely Czibula, Gabriela Czibula and Maria Iuliana Bocicor', Affiliations='' 
INSERT INTO publications_cache SET Title='A Reinforcement Learning Based Framework for Solving Optimization Problems', ProfessorId='7', Authors='Istvan Gergely Czibula, Gabriela Czibula and Maria Iuliana Bocicor', Affiliations='' 
INSERT INTO publications_cache SET Title='Modele pentru problema plierii proteinei', ProfessorId='7', Authors='Maria Iuliana Bocicor', Affiliations='' 
INSERT INTO publications_cache SET Title='Bioinformatica si aplicatiile ei', ProfessorId='7', Authors='Maria Iuliana Bocicor', Affiliations='' 
INSERT INTO publications_cache SET Title='Algoritmi evolutivi aplicati in chemoterapie', ProfessorId='7', Authors='Maria Iuliana Bocicor', Affiliations='' 
INSERT INTO publications_cache SET Title='Peer-to-peer messenger-H3llo', ProfessorId='7', Authors='Alexandru Radovici, Bocicor Maria Iuliana, Stoica Ovidiu', Affiliations=''



In [148]:

    
mariadb_connection.close()

Conclusion

In the end, the DB only required ~2 manual modifications (deletions) with this code.

Out of the 46 papers, 32 were inserted with unique titles.